In [14]:

    

import pyexcel as p

sheet = p.get_sheet(url='https://raw.githubusercontent.com/pyexcel/pyexcel-chart/master/hesa-students-data-2005-2015.csv")
sheet.top()


    

    
Out[14]:




pyexcel sheet:


Year   
Postgraduate part-time
Postgraduate full-time
Undergraduate part-time
Undergraduate full-time
Total    
2005/06
114,940               
155,665               
337,240                
450,485                
1,058,330
2006/07
116,220               
162,575               
341,035                
437,775                
1,057,610
2007/08
116,570               
161,015               
332,320                
458,575                
1,068,475
2008/09
129,055               
177,595               
344,775                
493,425                
1,144,850

In [15]:

    

sheet.column[1]


    

    
Out[15]:





['Postgraduate part-time',
 '114,940',
 '116,220',
 '116,570',
 '129,055',
 '132,790',
 '127,750',
 '109,535',
 '102,890',
 '106,260',
 '107,950',
 '107,120']

In [16]:

    

def to_integer(cell):
    if ',' in cell:
        cell = cell.replace(',', '')
        cell = int(cell)
    return cell

sheet.column.format([1,2,3,4,5], to_integer)
#sheet.plot(chart_type='bar')
sheet.column[1]


    

    
Out[16]:





['Postgraduate part-time',
 114940,
 116220,
 116570,
 129055,
 132790,
 127750,
 109535,
 102890,
 106260,
 107950,
 107120]

In [17]:

    

del sheet.column[5]


    

In [18]:

    

sheet.plot(
    chart_type='stackedbar',
    title='First year students by level and mode of study 2005/06 to 2015/16',
    legend_at_bottom=True, legend_at_bottom_columns=2,
    range=(0, 1200000)
)


    

    
Out[18]: